Intro To DF Part 3 Lab(Python)
Loading...

Intro To DataFrames, Lab #3

De-Duping Data

Spark Logo Tiny Classroom-Setup

For each lesson to execute correctly, please make sure to run the Classroom-Setup cell at the start of each lesson (see the next cell) and the Classroom-Cleanup cell at the end of each lesson.

%run "../Includes/Classroom-Setup"

Spark Logo Tiny Hints

  • Use the API docs. Specifically, you might find DataFrame and functions to be helpful.
  • It's helpful to look at the file first, so you can check the format. dbutils.fs.head() (or just %fs head) is a big help here.
%fs head dbfs:/mnt/training/dataframes/people-with-dups.txt
[Truncated to first 65536 bytes] firstName:middleName:lastName:gender:birthDate:salary:ssn Emanuel:Wallace:Panton:M:1988-03-04:101255:935-90-7627 Eloisa:Rubye:Cayouette:F:2000-06-20:204031:935-89-9009 Cathi:Svetlana:Prins:F:2012-12-22:35895:959-30-7957 Mitchel:Andres:Mozdzierz:M:1966-05-06:55108:989-27-8093 Angla:Melba:Hartzheim:F:1938-07-26:13199:935-27-4276 Rachel:Marlin:Borremans:F:1923-02-23:67070:996-41-8616 Catarina:Phylicia:Dominic:F:1969-09-29:201021:999-84-8888 Antione:Randy:Hamacher:M:2004-03-05:271486:917-96-3554 Madaline:Shawanda:Piszczek:F:1996-03-17:183944:963-87-9974 Luciano:Norbert:Sarcone:M:1962-12-14:73069:909-96-1669 Newton:Jose:Piacente:M:1969-11-05:264422:967-61-8575 Gretta:Jennefer:Dipinto:F:1921-10-28:118497:907-49-2510 Jenni:Janella:Mcquiston:F:1969-07-11:137418:932-55-7164 Malena:Apryl:Kings:F:1980-01-08:98204:934-48-2334 Willy:Russell:Merker:M:1967-10-10:41026:992-83-4829 Jami:Allen:Mulkerin:F:1958-08-08:236024:934-86-4126 Fernando:Lowell:Zebell:M:1955-07-03:246516:951-57-6196 Garnet:Helaine:Edghill:F:1985-05-15:97125:979-42-4409 Siu:Cherrie:Lechelt:F:2012-07-24:148331:906-85-3202 Randal:Osvaldo:Torma:M:2013-12-17:275086:982-68-6906 Myles:Stuart:Miskell:M:1928-05-17:280726:992-89-2715 Conrad:Donnie:Piatkowski:M:1920-11-17:59935:916-33-7831 Darcel:Fleta:Czyrnik:F:1994-09-05:99641:995-95-8909 Juliane:Hallie:Vuillemot:F:1972-01-11:203415:950-17-2657 Cordia:Estella:Scheiber:F:1924-03-13:214853:965-74-4739 Bryon:Isiah:Nazario:M:2002-02-26:201478:963-38-1755 Alex:Gilbert:Trigueros:M:1990-12-30:271591:999-60-3232 Irwin:Rene:Zalesky:M:1931-06-20:122599:974-53-6387 Deandre:Brent:Bailor:M:1954-08-07:93429:920-78-9780 Cheree:Dorethea:Anspaugh:F:1985-01-17:278860:961-36-6578 Zachariah:Harris:Reemer:M:1924-12-16:238892:944-32-3013 See:Sharen:Howryla:F:1979-12-30:169570:925-12-1644 Mozella:Necole:Giannakopoulo:F:1993-08-24:40880:980-93-4844 David:Tracy:Delatrinidad:M:1932-01-26:85003:993-37-2066 Michel:Loren:Sandoz:M:1925-05-04:270046:948-56-4284 Graham:Denny:Apresa:M:1966-07-14:209118:928-67-3592 Kattie:Sammie:Ercek:F:2002-07-26:211993:996-32-1564 Shaunna:Kathlene:Amunrud:F:1965-07-01:234090:916-53-6216 Leeann:Madeleine:Clater:F:1976-10-26:100705:946-41-7003 Garry:Lino:Galm:M:1934-08-14:168769:994-29-1678 Shelly:Marhta:Krenzke:F:1915-05-08:270492:967-71-8565 Shantelle:Zoe:Spicher:F:1952-12-11:183419:989-79-8274 Yessenia:Lucina:Fred:F:1967-04-21:131376:990-95-7077 Del:Maynard:Dzurnak:M:1960-01-31:276319:938-46-9967 Maximina:Kirsten:Barranco:F:2004-11-05:257482:938-70-3631 Shasta:Bette:Licausi:F:2006-05-26:273311:929-84-1247 Wendell:Bud:Landi:M:2012-03-06:61215:987-95-9502 Sabine:Petronila:Lambertson:F:1937-03-31:274044:916-95-8546 Leonard:Filiberto:Sellberg:M:1982-05-25:264070:965-65-6038 Demetrice:Flossie:Schehr:F:1958-03-16:245090:990-42-7824 Reyes:Gilberto:Schlabs:M:1997-07-11:252679:906-83-6847 Bernard:Reggie:Coache:M:1960-06-23:53020:941-56-6401 Lavette:Elouise:Riedinger:F:1950-11-21:51371:913-81-9468 Edmund:Nicolas:Majocka:M:1974-05-26:298673:921-55-7816 Deana:Marcie:Malle:F:2011-06-24:15388:973-52-9173 Claudio:Leopoldo:Ealand:M:1916-01-14:158319:929-61-6825 Lucretia:Divina:Parnell:F:2011-05-30:41054:963-43-3135 Myrtis:Yaeko:Maciarello:F:1941-11-16:191903:996-58-7685 Cordie:Cara:Sheilds:F:2007-02-08:219449:950-98-5411 Michell:Corinne:Himmelspach:F:1968-02-27:154658:905-67-9613 Major:Shawn:Garay:M:1934-12-18:79152:904-49-5993 Andrew:Darnell:Kniceley:M:1966-09-02:25955:987-26-4880 Shasta:Floria:Messineo:F:2008-02-23:30339:925-83-2833 Madalene:Arline:Vanholland:F:1945-05-14:47734:977-68-6192 Clare:So:Bieker:F:1922-04-07:14603:922-40-9560 Audrey:Lorrine:Sprewell:F:1932-10-25:283164:997-53-7925 ARLEN:HAYDEN:CARVILL:M:1986-05-24:66754:918339442 Maybelle:Honey:Jolicoeur:F:1923-02-10:239772:902-46-1282 Darwin:Cedric:Gompf:M:1954-03-19:152991:926-88-9050 Jonelle:Maryam:Berkstresser:F:1944-11-17:253619:935-62-7974 Lynsey:Marcelina:Dagrella:F:1969-03-01:209989:978-42-7296 Robert:Jessie:Anaya:M:1922-09-30:136381:956-53-6437 Max:Fletcher:Hoople:M:1996-04-08:205848:953-50-6974 CORNELIUS:NORMAN:LITTERAL:M:1931-12-19:244663:904721924 Temika:Tabetha:Krolikowski:F:1924-02-07:82498:994-27-4063 Fritz:Louis:Wechselblatt:M:2000-01-16:154897:972-28-2152 Elouise:Eun:Quiet:F:1997-06-15:20152:963-25-6361 Jenniffer:Mika:Hollowell:F:1979-12-27:293462:941-95-4384 Edwin:Fritz:Ehresman:M:1959-10-02:236463:919-39-5692 Barry:Colby:Zidzik:M:1998-12-09:206651:927-27-9653 Almeda:Alishia:Airth:F:1974-03-21:51512:938-43-3006 Darleen:Sharron:Matthews:F:1971-03-05:118422:965-56-2290 Garrett:Freeman:Records:M:1967-01-24:221687:919-65-9079 Sarina:France:Memmo:F:1962-03-03:88475:968-97-7178 Marsha:Roselyn:Sorbo:F:1999-09-13:91894:946-59-2346 Hilda:Sunny:Boehner:F:1952-02-24:130766:926-35-7508 Elicia:Lakeshia:Swentzel:F:1990-12-03:34074:907-20-7781 Cyril:Dalton:Groom:M:2010-09-18:68006:987-58-4363 Jimmie:Lawrence:Woodward:M:1968-05-12:37514:984-63-5828 Kelsie:Cassandra:Rozman:F:1955-09-14:144209:937-37-4674 Blair:Darnell:Angton:M:1963-03-18:54239:972-56-5352 Erick:Gaylord:Luallen:M:2001-03-10:195364:982-97-1174 Lucas:Dino:Maw:M:1939-06-23:181173:954-79-9625 Dino:Frank:Petrucelli:M:1979-11-25:60266:966-73-8544 Tommie:Rob:Chounlapane:M:1918-07-26:35002:910-22-5705 Bea:Mallie:Loperena:F:1996-05-24:172887:955-29-4616 Debora:Kayleen:Berczel:F:1974-11-04:198482:974-52-7615 Obdulia:Marylin:Leemow:F:1934-12-26:91920:964-35-1540 Garret:Ricky:Neifert:M:1973-10-08:223061:944-34-9864 Mose:Micheal:Rawling:M:1924-10-14:53447:926-61-2609 Carmina:Angelic:Nuesca:F:1977-05-20:142958:951-56-1923 Bob:Efren:Parga:M:1932-01-04:248063:999-78-6792 Stephania:Shirley:Maines:F:1970-02-08:33733:931-32-5509 Cami:Josefine:Neat:F:1945-04-18:231234:985-46-8325 Darcy:Morgan:Barkley:F:1973-11-04:153645:916-24-1139 Cecille:Xiao:Fatchett:F:1966-06-23:39688:981-44-6596 Awilda:Reta:Bonds:F:2004-10-30:24254:960-42-3200 James:Jerrold:Wolma:M:2006-01-25:154974:973-72-3674 Claud:Freeman:Bihari:M:1973-02-16:207536:919-53-6084 Billie:Ezekiel:Followell:M:1982-12-06:224666:913-59-2510 Adelia:Latonya:Urlaub:F:2001-03-23:136907:919-67-3521 Lynwood:Randell:Byous:M:1964-10-21:39977:965-93-8390 Roni:Emmie:Turso:F:1969-06-10:43049:980-22-7509 Sheilah:Trudi:Lilleberg:F:1956-03-24:191697:993-33-5586 Malvina:Lanette:Hartness:F:1940-08-14:177745:908-66-7175 Rochell:Nicola:Huh:F:1925-12-27:110966:936-84-6765 Lucia:Pearly:Scobee:F:1964-05-15:230949:913-63-6237 JONATHAN:JULIAN:CAZORLA:M:1915-05-20:266457:959878516 Marvin:Devon:Robin:M:1962-07-18:26662:993-24-1711 Kami:Lorrine:Schaper:F:1998-08-04:135446:997-28-1564 Kasi:Winnie:Buzza:F:1981-09-07:104711:981-82-9401 Luann:Elsa:Ibsen:F:1936-02-21:195235:942-89-1746 Gwyn:Nichol:Waltemath:F:1934-07-09:297958:923-88-6201 Vincenzo:Tim:Nealon:M:1977-07-03:255390:934-21-2608 Denver:Shon:Caho:M:1971-12-17:27360:921-25-7131 Jess:Frederic:Vankammen:M:1942-10-02:107405:983-28-5981 Harvey:Claudio:Maitland:M:1946-07-31:195280:986-79-6027 Mohammad:Chad:Cardle:M:1985-04-21:92744:927-17-9121 Margarette:Vasiliki:Bacerra:F:2011-03-16:54334:984-23-2965 EMORY:GARRETT:BISARRA:M:1929-07-21:39437:975422585 Monty:Josiah:Picciuto:M:1940-10-14:140628:930-59-7861 Don:Roger:Soll:M:1971-07-21:123428:946-35-9195 Brendon:Guy:Angelillo:M:1940-07-11:127761:958-93-3385 Maxwell:Byron:Iacobucci:M:1948-02-24:215373:972-12-9005 Dung:Marylyn:Trethewey:F:1943-10-15:235863:945-85-7157 Gabriel:Sterling:Coplen:M:1947-09-25:89873:945-18-1963 Almeda:Lizzie:Lecomte:F:1994-09-22:179411:923-93-1226 Darrick:Sanford:Neef:M:1919-12-16:225795:985-15-5842 Scarlett:Georgina:Backues:F:2004-01-24:139585:962-10-8796 Elma:Liane:Mcclatchey:F:2015-02-03:25532:900-72-1168 Perry:August:Gerbig:M:1981-04-24:175376:988-20-4806 Kathlene:Renea:Churley:F:1954-09-26:21242:929-37-1499 Willene:Kandi:Jackowiak:F:1990-10-24:32163:910-11-9710 Sheldon:Grover:Wixted:M:1921-06-06:73662:948-83-5840 Jenna:Marybelle:Fredrikson:F:1944-12-06:163537:998-99-8395 Viola:Elisa:Gares:F:1986-07-11:169002:966-57-2566 Rozanne:Daniell:Warhurst:F:1979-01-03:162928:923-55-6208 Delmar:Herman:Kostiv:M:1965-12-10:165513:974-69-9877 Porter:Alfonso:Mccelland:M:1994-04-12:93678:971-37-8804 Reuben:Zachariah:Wagle:M:1925-04-25:291830:977-40-1724 Dominick:David:Walner:M:1977-10-21:58894:944-42-5417 Tyson:Jefferson:Gemes:M:1918-01-30:20988:924-51-8570 Shanna:Lorine:Alberti:F:1958-05-19:233998:949-42-2448 Tambra:Robbi:Ballog:F:1948-02-27:199000:961-97-1552 Evan:Florentino:Glaviano:M:1998-01-10:110165:929-31-4982 Elizbeth:Shasta:Tuggie:F:1991-02-14:40847:990-45-2792 Greg:Benjamin:Trevillian:M:1968-04-25:252528:990-82-8264 Jan:Refugio:Nute:M:2014-07-20:85729:959-83-9540 Melodee:Filomena:Heckathorn:F:1999-06-24:192223:996-39-9023 Hershel:Hubert:Formaggioni:M:1916-09-03:106615:970-86-9535 Ying:Cheyenne:Vanhoozer:F:1931-09-16:115686:946-62-8432 Cherise:Shena:Munshower:F:1945-09-07:91582:986-22-3991 Jeffery:Lloyd:Redgate:M:2006-08-31:218520:926-95-7766 Lindsay:Dion:Meserole:M:1941-05-17:43387:995-32-3127 Heike:Milissa:Baro:F:1942-03-07:60024:948-17-5120 Jaqueline:Daphine:Wienberg:F:2007-12-19:69488:985-41-9187 Reed:Jerold:Cheeseboro:M:1932-11-10:246455:914-21-3953 Kendrick:Chad:Whittenton:M:1957-05-26:220977:980-74-8567 Leonie:Vera:Grudzien:F:2002-09-16:169398:913-55-5184 Temika:Nichol:Dauphin:F:1994-09-24:149527:979-81-4055 Duane:Colin:Sharrett:M:1986-12-16:265193:988-55-7731 Santos:Timothy:Gnoza:M:2006-12-14:95172:940-91-7130 Margurite:Wynona:Lanosga:F:1926-05-12:242087:972-21-3250 Charlie:Maryanne:Higgenbottom:F:1953-01-03:96209:945-24-4618 Florencio:Kevin:Pasek:M:2003-01-14:119507:913-55-8343 Jamee:Cristy:Kron:F:1947-08-12:178475:940-35-2361 Blair:Reed:Fede:M:1957-08-17:53401:901-45-2498 Shelba:Reagan:Coffell:F:1995-05-17:192606:942-87-4388 Sonny:Mickey:Fabacher:M:2006-01-01:192611:948-18-3053 Yasmine:Sherlene:Harcus:F:1918-04-29:167953:905-30-8611 Rubin:Anthony:Bazzle:M:1976-08-27:217866:966-69-6456 Ethan:Rene:Hohstadt:M:1961-09-18:12432:965-88-7623 Valentine:Millard:Pellissier:M:1932-05-24:87925:974-39-3514 Terrence:Clint:Chad:M:1985-01-31:135569:960-24-3850 Vesta:Joyce:Varenhorst:F:2006-01-09:126011:924-20-8221 Tasia:Aracely:Mulliner:F:2011-03-24:226979:956-92-1033 Heath:Sheldon:Tillery:M:1946-08-09:154378:947-74-3837 LYNDA:BERNEICE:KLEY:F:1966-06-19:76999:932799801 Malia:Elease:Viscia:F:1992-10-25:85311:931-19-5423 Louis:Ferdinand:Sturgell:M:1941-09-30:74181:953-44-2021 Maya:Crissy:Honzel:F:1969-01-16:244644:938-60-5790 Yoshiko:Leonor:Onyeagu:F:1932-06-23:191722:960-26-5924 Sergio:Billie:Selman:M:1921-08-19:142241:958-70-9141 Venice:Sophie:Rolek:F:1982-11-05:292706:949-89-1731 Kathleen:Iona:Kibby:F:1982-04-07:46017:992-18-6118 Shelby:Herbert:Men:M:1936-02-18:269165:992-49-5448 Zelda:Shalonda:Dorschner:F:1936-06-20:213221:927-64-6781 Alan:Britt:Zakarian:M:1957-03-03:244377:918-49-8692 THOMASINE:SHARAN:PONO:F:1930-08-27:15815:910327375 Flora:Gisela:Chacon:F:1987-07-21:286900:910-55-9569 Luz:Deloras:Minassian:F:1976-11-12:180748:955-61-8296 Dominique:Berniece:Dinuzzo:F:1952-08-01:247433:970-37-8770 Anisa:Eura:Bingaman:F:1974-06-24:202343:974-72-6756 Nikole:Lynelle:Dolven:F:1954-10-07:124399:948-16-5886 Herman:Dudley:Claar:M:1999-07-25:128160:949-60-8249 Wade:Jefferey:Buttars:M:1968-10-18:254530:970-73-3800 Wally:Cruz:Escalona:M:1961-05-13:183779:942-75-3451 Elfreda:Dagmar:Douyette:F:1955-08-05:64840:998-87-4937 Moriah:Goldie:Koehn:F:2012-01-15:168664:999-24-3966 Bertram:Ken:Sarcone:M:2012-01-17:215216:967-47-3488 Madie:Daria:Markevich:F:1985-06-19:115162:955-26-7828 Jules:Gustavo:Salmonson:M:1949-12-17:202018:948-23-7046 Austin:Richard:Muskett:M:1926-11-23:32670:995-34-4031 Rob:Pierre:Drumheiser:M:1937-01-31:47615:993-29-5527 Nathaniel:Reinaldo:Tyszko:M:1924-03-26:12707:938-88-2750 Debbie:Hailey:Corriveau:F:1956-04-27:97352:993-74-7479 Harris:Heriberto:Burleson:M:1932-06-07:230115:977-89-8893 Lita:Keesha:Casten:F:1983-04-04:279849:957-59-8591 Frederic:Guadalupe:Sobrino:M:1927-04-27:45961:996-57-9672 Jc:Cole:Imada:M:1987-03-26:153831:921-17-3836 Drucilla:Renata:Stager:F:1977-12-22:63470:994-42-9469 Shelby:Alysa:Kurpinski:F:1944-08-26:165203:940-34-6842 Richard:Oren:Papetti:M:1958-05-21:178495:902-42-1859 Fred:Erin:Fleitman:M:1915-08-13:269940:945-19-4695 Noella:Vida:Hefty:F:1938-07-28:70902:969-31-6834 Cheri:Nelle:Pesenti:F:1951-01-09:223090:930-42-9304 Mauricio:Seth:Campillo:M:1958-05-22:293466:970-82-9161 Lavinia:Amy:Bramlette:F:1947-01-23:266924:908-96-9743 Belva:Ma:Schorn:F:1997-01-07:98313:994-25-8708 Ozell:Bridget:Teaff:F:1984-04-30:31205:924-50-5347 Angel:Cyril:Mccrumb:M:1983-01-17:197055:979-94-7995 Gregory:Harvey:Carbajal:M:2011-07-25:139518:937-44-2271 Delisa:Donella:Illig:F:1940-06-08:173977:977-51-3766 Sheldon:Kory:Chrysler:M:1965-09-22:36904:968-35-4549 Joline:Annmarie:Payment:F:1954-01-17:184955:943-22-3421 Benedict:Colby:Diani:M:1964-01-12:82062:902-78-9595 Cristopher:Sid:Northan:M:1917-12-13:252512:997-25-1109 Ilene:Jerica:Amabile:F:1955-01-29:50401:997-17-9474 Pamila:Tiera:Franzone:F:1965-08-13:130877:975-37-7577 Lai:Hermina:Puffenberger:F:1955-11-12:72210:910-91-8134 Chi:Benton:Britcher:M:1979-07-27:159778:994-96-5537 Pam:Brandie:Binns:F:2001-08-16:161184:967-70-1498 Noriko:Mariana:Vrbka:F:2012-12-14:133439:988-39-4246 Vanesa:Sana:Kimbrel:F:1927-05-06:17768:923-67-7509 Chrystal:Renea:Meisner:F:1981-06-26:192257:954-33-4755 Wilbert:Johnny:Hazelett:M:1981-08-02:216671:997-82-7781 Cole:Homer:Arvidson:M:1948-03-19:60212:977-81-3749 Isaiah:Rogelio:Pflum:M:1943-04-10:172376:992-73-1930 Lacey:Leigha:Meranto:F:1916-04-14:10125:953-10-1377 Jaimee:Lanora:Ciarrocchi:F:2010-05-31:292872:969-80-9160 Mila:Maureen:Eisenhart:F:2010-06-24:91112:929-62-2582 Hershel:Ty:Wakeling:M:1940-06-19:196627:978-15-8473 Dee:Boyd:Bonier:M:1966-09-22:229408:967-33-2132 Brooks:Max:Ona:M:1998-12-28:293552:963-13-9788 Brian:Renato:Bucholtz:M:1947-12-01:285620:923-25-8279 Jonathon:Leon:Sherles:M:1954-12-31:33123:990-26-7511 Adolph:Alex:Chulla:M:1974-09-01:124862:923-54-8251 Darius:Thad:Sissell:M:1980-05-27:121631:979-28-5938 Myong:Daryl:Unglaub:F:1962-07-11:235945:902-23-4394 Lashaun:Pauletta:Harcus:F:2014-02-23:291112:922-29-4618 Jewell:Marcie:Pallotta:F:1946-07-09:35544:939-31-7158 Toby:Leroy:Prather:M:2004-09-19:224953:915-92-5382 Fannie:Porsche:Gaddie:F:1928-10-08:164744:915-40-9763 Tad:Joe:Paladini:M:1998-03-24:275999:940-74-2428 Myron:Jan:Woolem:M:1928-09-19:261695:952-15-5774 Boyd:Barton:Sabourin:M:1983-12-19:170095:926-28-2732 Avelina:Maisie:Bodford:F:1922-02-22:225113:968-16-7334 Rutha:Yolande:Gilding:F:1945-07-27:139347:926-40-6601 Chantal:Dorcas:Whisler:F:2014-09-20:162385:923-57-2300 Allyson:Tricia:Koeck:F:1973-03-08:19940:951-85-6557 Edwina:Claudia:Charpentier:F:2004-03-28:235837:947-80-8117 Alberta:Rasheeda:Rodiguez:F:1950-07-28:181624:934-71-7063 Thomas:Jay:Pforr:M:1946-06-10:11991:926-25-8360 Arturo:Art:Galow:M:1971-07-10:296665:921-12-7008 Damion:Normand:Muslim:M:1920-10-15:26498:965-56-7224 Delphine:Lelah:Stmichel:F:1921-09-14:169938:903-10-6132 Jacqualine:Meredith:Micciche:F:1929-05-25:150033:935-71-3384 Palmer:Ray:Lecznar:M:2008-08-22:166652:982-66-6760 Roxane:Sheila:Trevithick:F:1940-02-20:298298:938-54-4256 Berniece:Kori:Sachetti:F:1995-08-31:175680:998-46-7198 Rolf:Lyman:Zaritsky:M:1992-06-25:29920:987-22-4665 Archie:Galen:Browning:M:1926-09-06:218368:927-22-2799 Bert:Jonah:Kallin:M:1947-11-30:143649:977-51-9861 Hayley:Aleta:Sterger:F:1923-10-29:247027:938-32-3185 Davis:Quincy:Shiyou:M:1929-05-31:102736:970-61-1091 Lory:Kimberlie:Chevalier:F:2011-03-05:159533:900-82-7532 Jeanette:Criselda:Veitz:F:1974-11-29:16378:949-11-4966 Raelene:Sigrid:Grimard:F:1981-08-26:131520:963-34-6229 Elbert:Sid:Savell:M:1941-02-06:26180:968-22-3460 Logan:Mario:Drozdowski:M:1944-05-15:110934:902-76-7626 Emory:Charlie:Oberhausen:M:1966-01-29:123028:935-64-9929 Raul:Augustus:Lefave:M:1951-09-07:108961:959-75-8086 Shawnna:Johnie:Pinales:F:1934-10-09:285693:989-51-5744 Camilla:Lorenza:Jeremiah:F:1952-09-24:97233:905-39-8564 Britni:Eryn:Sahu:F:1963-12-09:62083:964-58-4191 Brooks:Jay:Bakowski:M:2001-09-26:228160:666-89-8783 Dotty:Bailey:Mozee:F:1963-06-08:290287:910-21-2759 Marcelo:Milan:Sciuto:M:1928-10-08:121761:942-42-2062 Robt:Weston:Shebby:M:1992-03-11:230956:955-18-5428 Wallace:Abdul:Domingue:M:1951-10-13:227673:914-90-3243 Veronika:Rosaline:Amato:F:2005-07-20:72726:977-47-1427 Jarred:Len:Kraig:M:1968-08-30:91110:994-91-4125 Sherita:Delaine:Zomberg:F:1998-09-17:167979:931-34-4793 Jefferey:Stephen:Kunkel:M:1987-03-11:170030:666-11-2631 Michale:Irwin:Molchan:M:1951-12-22:127782:972-96-3312 Cedrick:Gayle:Zweier:M:1983-01-07:75146:998-34-4764 Karrie:Anika:Alwardt:F:1975-01-09:132825:932-26-1032 Luetta:Eula:Satter:F:1961-06-24:76697:984-71-8218 Shad:Kasey:Crenwelge:M:1941-04-08:19853:954-70-6471 Viola:Barbar:Coskey:F:1966-12-16:228075:958-37-5173 Dewey:Pablo:Entz:M:2002-02-14:94001:954-25-8039 Terrence:Giovanni:Bergeaux:M:1984-04-08:57741:929-15-8253 Stanley:Ronny:Creel:M:1994-01-22:284758:978-23-2755 Helene:Nicolette:Gunsolus:F:1920-09-18:125852:956-12-7516 Shirleen:Karole:Dolle:F:1961-02-10:253778:966-45-6047 Jarrett:Silas:Sodano:M:1972-09-20:191024:933-68-8577 Eddie:Heath:Pritzker:M:1950-03-31:211632:960-62-5357 Karen:Alisa:Schrameck:F:1915-11-29:160450:948-19-9406 Esmeralda:Beverly:Argo:F:1994-02-12:167532:908-94-8341 Tandy:Margaret:Cologie:F:1932-07-05:262641:939-36-6585 Katheryn:Carrie:Mahar:F:1921-04-06:172915:925-36-2763 Taylor:Palmer:Reposa:M:1971-12-16:263964:908-15-6441 Nicolas:Virgilio:Konen:M:1925-08-19:299065:951-23-6625 Margarite:Marinda:Santulli:F:1933-11-25:144710:975-66-8601 Valentine:Eric:Adame:M:1932-12-09:50534:968-31-9332 Eldon:Billy:Godfray:M:1956-03-18:78283:986-16-4576 Dwight:Roger:Guintanilla:M:1987-12-18:234186:974-51-8132 Jamie:Courtney:Hollow:M:2012-05-29:32655:954-86-6134 Elmer:Jesse:Dicocco:M:1919-12-27:27091:905-27-3648 CARON:KATHLINE:REISCH:F:1925-02-19:208041:931684815 Lela:Otelia:Zaccagnini:F:1930-02-27:297392:979-62-1058 Rubin:Roger:Engroff:M:2008-06-04:76107:988-48-9570 Domonique:Melita:Gollin:F:1954-05-30:12623:975-75-9305 Grady:Eusebio:Ayars:M:1933-12-03:192293:915-31-4135 Cedric:Mac:Wilber:M:1926-09-18:83157:966-98-8939 Francesca:Aisha:Martines:F:2010-08-20:78218:972-17-9683 Diamond:Micki:Tiemeyer:F:1967-05-26:73802:900-94-4158 Son:Eliseo:Guajardo:M:1990-10-17:231409:989-39-7895 Alda:Mafalda:Binstock:F:1963-08-17:193279:957-25-3339 Dorcas:Lenita:Soldeo:F:1987-06-24:80529:983-75-1398 Belen:Luetta:Sewell:F:1993-03-23:180905:950-47-3704 Odessa:Cristal:Dumas:F:2006-02-17:164941:906-40-9420 Dwight:Ross:Shewbridge:M:1980-05-08:279767:969-90-2884 Barbra:Manuela:Viverette:F:1926-03-19:115798:949-13-6730 SCOT:RICKIE:STOTHARD:M:1987-11-07:285417:915778765 Cinda:Golda:Engholm:F:2006-10-24:223509:991-55-1135 Tamisha:Youlanda:Silloway:F:1926-10-17:287128:959-27-8811 Jaleesa:Tequila:Elmblad:F:1962-07-13:209833:940-94-9902 Marcy:Florentina:Gaber:F:1953-05-10:289416:980-64-6798 Leonel:Valentin:Wolinski:M:1997-11-19:293301:924-14-4393 Alfred:Zack:Carnohan:M:1991-04-29:286840:934-80-4710 Chi:Henry:Elgas:M:1969-11-11:289058:990-21-9263 Darrin:Titus:Schoenfelder:M:1962-12-08:127983:921-22-9395 ARDELL:MARLYN:FAST:F:1945-04-28:175635:911999762 Rema:Kala:Ponciano:F:2013-05-12:209888:960-44-5421 Athena:Kandi:Troup:F:1971-11-24:211149:955-75-3288 EMOGENE:SHAWNA:CHESTER:F:1938-07-17:130085:949735778 Beckie:Rosalie:Cwik:F:1995-02-19:80046:905-98-7211 Rosella:Alexia:But:F:2013-01-03:223437:930-41-1220 Gene:Jason:Harapat:M:2006-02-02:101127:915-83-3083 Alexis:Deandre:Brocklehurst:M:1932-02-07:153212:908-81-9294 Leslie:Dante:Staudinger:M:1956-03-10:75006:915-66-4534 Dona:Tanesha:Gaseoma:F:1979-06-12:94326:986-18-4209 Gregorio:Forrest:Gumpert:M:1983-11-30:191979:928-84-1440 Virgilio:Nelson:Friday:M:1915-04-17:252704:981-24-4227 Darla:Hermelinda:Serrao:F:2007-08-23:35107:999-87-3110 Cyril:Otis:Thane:M:2001-05-17:20386:951-11-8307 Janise:Kylee:Branscomb:F:2011-05-07:126359:907-31-5623 Ira:Tyree:Mcennis:M:1926-06-18:66811:910-95-7983 Lavona:Beth:Reitema:F:1930-04-01:111506:946-50-5522 Arturo:Hai:Buras:M:1954-06-06:93443:904-35-3802 Sirena:Nicolle:Colas:F:1976-12-04:206910:923-52-4399 Almeda:Bebe:Park:F:1948-03-03:138889:956-33-7214 Benedict:Edwardo:Dannhaus:M:1985-06-03:285049:953-60-8682 Graig:Rico:Rowse:M:1939-04-21:206131:997-96-3497 Sherly:Kym:Grumney:F:1984-09-08:251050:937-81-8534 Sabine:Cameron:Laurie:F:1960-08-22:150464:996-54-6307 Jamey:Tracy:Cinalli:M:1953-11-10:148529:939-76-2489 Amanda:Kaley:Choute:F:1962-12-22:273952:929-87-4650 Rolande:Kelly:Colston:F:1991-09-26:75592:979-39-1948 Todd:Sylvester:Jenny:M:1921-11-25:92378:972-14-9409 Monte:Doyle:Bissett:M:2004-05-23:289831:930-24-2376 Kristie:Aliza:Griggers:F:1953-02-27:44182:666-89-7936 Shayne:Numbers:Helsel:M:1943-09-25:140317:919-24-2132 Columbus:Cody:Weesner:M:1933-12-03:41077:939-52-7350 Silas:Hipolito:Roanhorse:M:1991-07-30:232402:906-60-8193 Randall:Glen:Ellegood:M:1994-12-15:121491:945-71-6380 Johnathon:Kirby:Kotecki:M:1953-04-03:181867:972-95-8272 Noble:Vito:Horn:M:1986-12-07:154812:909-41-9433 Marjorie:Dara:Cuadras:F:2007-04-09:128373:948-71-5894 Betsey:Bok:Standefer:F:1979-09-08:238583:904-86-3711 Wilda:Mira:Pullara:F:2010-11-26:217468:921-37-1803 Roxanna:Margaretta:Chasteen:F:1957-06-29:161307:971-21-7545 Veronika:Ardith:Terrones:F:1920-04-29:269455:934-51-4958 Dorian:Sid:Desfosses:M:1979-11-23:245579:922-62-1250 Sharita:Sherron:Smedley:F:1998-06-07:281979:984-47-2067 Renee:Lucy:Hullinger:F:1971-11-22:155308:914-63-9423 Darrel:Ashley:Gama:M:1950-04-23:191490:930-41-8108 Charita:Katelin:Hookfin:F:2007-07-30:189272:978-16-7905 Tierra:Shemeka:Birenbaum:F:1984-08-31:81709:995-95-6056 Joanne:Jeanine:Lighthill:F:1961-11-09:130995:991-47-6903 Lashonda:Nga:Kendricks:F:1970-08-28:18958:966-24-8984 Noelle:Savannah:Paaske:F:1923-05-11:66494:950-88-3465 Chung:Brandon:Scotty:M:1949-09-10:185612:949-87-4493 Joshua:Chester:Nurse:M:1942-01-25:202148:971-42-4294 Melvina:Tobie:Hegan:F:2008-09-22:110047:963-66-4217 Tien:Christia:Ahhee:F:1933-09-04:126497:990-39-1931 Idell:Melda:Myers:F:1951-06-16:178606:907-32-6463 Boyce:Luke:Mcgrapth:M:1997-05-04:195226:916-91-4133 Carolyn:Tamika:Ownbey:F:1963-02-01:268837:900-41-4016 Percy:Valentin:Therres:M:1952-04-06:58925:942-88-9450 Keli:Cicely:Surman:F:1949-05-03:27249:962-84-3224 Stefan:Armando:Synder:M:1919-07-28:126358:961-52-2721 Jamar:Domenic:Rellama:M:2003-09-20:109953:930-75-9656 Morris:Forest:Cawley:M:1931-06-25:145142:935-17-6525 Don:Moses:Hosley:M:1978-12-24:294615:951-50-8037 Kris:Damion:Fagundes:M:1963-08-03:112215:992-58-6458 Octavio:Carmen:Binsfeld:M:1990-08-08:90948:934-90-9534 Gussie:Ivory:Mccaster:F:1968-12-29:124602:901-55-1287 Jerold:Thad:Posso:M:1999-03-06:246754:941-88-8266 Ambrose:Mauro:Schmoldt:M:1964-09-29:99394:914-53-3874 Gerry:Fredric:Heriford:M:1971-08-19:231384:986-72-5170 Deangelo:Maximo:Seier:M:1942-08-04:157521:953-56-9345 Darrick:Charles:Tagaban:M:1949-08-20:257150:995-37-2376 Elizabeth:Beatris:Brostoff:F:2015-03-21:237386:951-37-7016 Epifania:Cortney:Wickson:F:1981-12-17:181104:925-21-4720 Brunilda:Christine:Botto:F:1944-10-13:167785:959-97-7061 Brooke:Jaleesa:Lemert:F:1975-08-16:159499:909-66-3152 Samira:Jacki:Warth:F:1991-04-15:187717:966-87-9428 GRANVILLE:VICENTE:MININGER:M:1986-01-11:166532:952239996 Jovita:Ebonie:Dippel:F:1932-03-11:121873:993-97-9382 Carolynn:Myrtie:Keator:F:1997-06-08:128571:957-21-2772 Sharika:Tama:Wycuff:F:1917-10-31:91834:900-45-7892 Laraine:Collen:Chouinard:F:1956-10-23:126954:956-57-4277 Luis:Zack:Pokswinski:M:1937-08-15:254028:974-16-4303 Jarrod:Danial:Viramontes:M:2011-03-21:41843:995-86-5116 Mila:Coleen:Lidke:F:2008-05-19:117047:905-59-4531 Roger:Ike:Deglow:M:2007-10-10:98472:965-79-1100 Mardell:Roselia:Speakman:F:1955-09-05:117367:928-36-5210 Malcolm:Leland:Martinis:M:1997-08-30:118433:998-74-8572 Nikole:Camellia:Gstohl:F:1957-11-09:296889:991-29-7200 Lowell:Ruben:Gislason:M:1927-04-10:61454:928-19-1287 Mamie:Cicely:Labeots:F:1995-05-06:288371:914-13-5398 Dean:Chauncey:Burts:M:1995-09-30:240641:913-89-3788 Brant:Mariano:Campanella:M:1980-09-11:228390:929-74-6180 Carmen:Mauro:Rayno:M:1966-02-23:62708:939-27-7557 Lavina:Armandina:Burzlaff:F:1967-09-11:171189:995-82-9398 Lida:Nakisha:Vuolo:F:1995-07-11:242352:952-14-7214 Conrad:Jayson:Durrah:M:1974-01-15:24345:995-95-8400 Randy:Darrick:Leemaster:M:1970-02-03:87813:941-77-7157 Marcelo:Virgil:Rajas:M:2000-01-29:199916:977-50-9252 Marcellus:Guadalupe:Dellaporta:M:2006-03-22:280826:950-66-5135 Mallory:Lashandra:Seliga:F:1939-12-03:82638:954-30-2430 Rodrigo:Pat:Eckis:M:2009-05-24:101923:919-69-9092 JEN:BREE:GREDER:F:1987-12-11:47096:976495465 Ned:Antony:Macke:M:2000-06-17:88946:934-85-5073 Tory:Frances:Boomhower:M:1935-03-17:248088:962-62-2141 Chase:Tommie:Knight:M:1965-04-13:38377:940-55-3362 Dean:Neil:Ratti:M:1947-08-10:136482:951-52-6186 Deshawn:Elijah:Pettyjohn:M:1964-07-28:291625:932-16-8339 Colette:Regina:Rumberger:F:1965-09-04:198481:902-98-9549 Ali:Elliot:Rav:M:1937-08-12:66481:952-84-6116 Jerry:Tyrone:Mckoy:M:2006-08-23:60389:984-53-1471 Maxwell:Ezra:Buttke:M:1947-10-21:13104:988-67-6029 Leonila:Veronique:Sabellico:F:1924-09-21:192772:939-96-8836 *** WARNING: skipped 15625 bytes of output *** Mickie:Jenise:Corkins:F:1939-08-13:165446:910-26-1410 Dorsey:Wilburn:Thonen:M:1918-06-21:220328:937-13-6208 Britany:Rebecka:Fortes:F:1955-03-19:102839:989-57-6533 Ursula:Ramonita:Gottsch:F:1925-04-12:194869:917-37-7866 LUCILA:EMMA:VIRGA:F:1989-12-05:139082:931479619 Harland:Trent:Gavell:M:1951-06-26:272404:965-92-7310 Maegan:Janelle:Rulon:F:1999-07-01:91911:907-24-5307 Sung:Jamaal:Gerstle:M:1973-08-29:47241:975-87-1151 Valery:Cleotilde:Berdux:F:1954-02-04:77771:981-78-3204 Denver:Bruno:Ospina:M:1952-12-17:143822:666-59-3554 Jessie:Kristian:Prindiville:F:2009-08-09:91913:901-22-5698 Alyssa:Sabine:Knoeppel:F:2002-02-27:149152:904-71-5562 Sparkle:Carin:Desiderio:F:1926-11-16:289075:986-39-8049 Stacie:Melinda:Boyarski:F:1993-07-31:187115:915-52-5036 Mae:Kendall:Lavezzo:F:1959-07-19:103694:938-15-1956 Newton:Boris:Delsol:M:1953-07-15:106555:999-81-9588 Brooks:Jordon:Gabrysch:M:1979-11-30:281699:955-69-3221 Ramon:Ezekiel:Lorber:M:1979-02-06:209689:980-61-4579 Jayson:Willie:Naik:M:1985-09-06:290352:973-51-6641 Venita:Rochell:Catania:F:1998-09-17:127327:666-60-3866 Nadene:Leila:Cortijo:F:1943-08-24:182686:981-43-2546 Keneth:Dewey:Brians:M:1928-07-20:275134:915-26-3076 Liane:Leatha:Topper:F:1963-01-18:183045:908-94-1578 Annemarie:Kaycee:Bora:F:1995-08-31:175351:928-70-4350 Ashton:Armandina:Bonita:F:2013-03-23:219894:914-94-4872 Robbyn:Janee:Newfield:F:1924-02-14:195926:936-97-4859 Brad:Rusty:Bressi:M:1976-02-21:204081:937-30-2601 Bernadine:Moira:Carollo:F:2000-06-23:26431:966-76-1352 Janeen:Pilar:Francies:F:2009-03-22:111782:947-80-3298 Ferdinand:Deshawn:Boulton:M:1965-12-11:49431:925-19-6776 Kera:Florencia:Demorizi:F:1966-10-20:212809:955-22-3661 Myrtis:Mariann:Ameigh:F:1959-01-25:138402:902-79-7939 George:Darren:Wauneka:M:1941-04-14:290267:927-86-1848 Sabrina:Arlene:Dare:F:1945-11-13:243654:968-42-6498 Ervin:Brooks:Hellweg:M:1926-11-24:172056:962-91-1353 Noah:Walker:Ariyoshi:M:1956-05-16:289184:993-67-4753 Aretha:Nisha:Betzner:F:1965-08-17:270216:992-88-4430 Gregg:Santiago:Juncaj:M:1927-12-13:266036:942-55-1416 Johnathan:Melvin:Sprayberry:M:1962-06-20:56898:913-72-6896 Bruno:Marty:Mciwraith:M:1992-06-29:134166:985-85-6476 Cleopatra:Tashina:Scruton:F:1986-11-18:16638:959-60-3783 Harlan:Fidel:Lanteigne:M:1944-10-14:29539:961-53-9096 Martha:Dora:Cushingberry:F:1966-06-01:248870:933-85-8953 Irene:Caroline:Parman:F:1975-08-10:230870:985-98-1056 Lanie:Cristen:Miskovich:F:2011-04-17:178596:914-46-3355 DEEDRA:CORY:MAGLAUGHLIN:F:1931-04-18:273223:962463793 Richie:Curt:Haag:M:2004-11-29:163941:973-54-6965 Buster:James:Malahan:M:1987-02-06:190408:939-59-2144 Jere:Willian:Laster:M:1950-07-12:228526:994-63-3116 Saundra:Matha:Ruiloba:F:1932-11-01:131390:999-58-5165 Shaneka:Dortha:Alcosiba:F:1958-05-21:243360:920-97-4899 Darline:Darcel:Lins:F:1989-03-23:165407:921-56-7785 Cleora:Alene:Huberman:F:1946-10-13:103696:916-67-4834 Rayford:Tommy:Auchmoody:M:2008-10-09:102111:981-56-6000 Billy:Dwayne:Lanfor:M:1936-11-12:13707:956-89-2526 Gail:Doug:Locks:M:1959-06-20:140173:935-89-5649 Elmo:Marcelino:Galson:M:1949-02-09:84900:921-60-6188 Isidro:Ollie:Boleyn:M:1928-08-16:294341:961-69-3372 Claudine:Juliet:Cloughly:F:2011-06-28:298378:925-15-3080 Tracey:Graig:Bonanni:M:1918-06-30:295539:967-63-8998 Camille:Brandy:Duttry:F:1962-07-06:73448:975-73-7169 Magdalen:Yael:Nickoley:F:1961-09-25:20485:934-33-2780 Ivan:Herbert:Anderegg:M:1917-05-08:79457:970-66-7739 Nathanael:Jimmie:Reha:M:1997-04-27:258358:919-16-5051 Del:Alec:Lynds:M:1989-11-12:183621:997-80-5543 Alfonzo:Jarred:Strate:M:2013-07-09:51905:987-64-7975 Denis:Elwood:Eshmon:M:1927-11-20:244281:902-98-4386 Erika:Arie:Stefanick:F:1953-01-27:289783:917-46-5492 Fern:Joan:Varty:F:1976-11-04:193111:924-13-4676 Monte:Charley:Reagor:M:1960-03-06:161156:983-58-2984 Rosita:Chrissy:Grubaugh:F:1991-05-18:252766:931-28-6163 Fairy:Debbie:Capaccino:F:1991-03-17:97088:972-83-9294 Roderick:Jorge:Adens:M:1966-04-17:134610:970-18-2766 Darwin:Weston:Dupar:M:1936-01-07:270527:989-76-5937 Syble:Loralee:Youngren:F:2012-08-13:129780:981-10-1015 Gwenda:Lula:Turcott:F:1974-09-09:69457:970-98-9952 Darryl:Felton:Mueller:M:1975-04-15:50797:996-21-1417 Tabetha:Genie:Gallante:F:1926-12-10:138016:903-89-6557 January:Dara:Locklin:F:1994-03-17:90153:984-18-2798 Garfield:Chance:Presas:M:2004-09-29:182519:919-67-8894 Danyelle:Loura:Neto:F:1991-12-16:35565:937-23-6966 Vicente:Efrain:Schmeisser:M:2005-12-18:193147:953-66-6779 Renaldo:Jeffery:Gosser:M:1980-06-05:276355:990-97-7500 Kenneth:Deandre:Reyner:M:1941-10-31:159545:975-10-6365 AUDRIE:JOANN:DETTORRE:F:1924-10-22:183400:909166947 Elena:Ligia:Lime:F:1953-05-12:36610:926-30-8942 Ivory:Garland:Hirpara:M:1980-10-02:235394:955-32-7990 Brant:Marcel:Prosperie:M:1981-08-18:80705:987-50-5439 Sydney:Burl:Yarrell:M:1977-12-31:123088:980-42-4065 Kandra:Josefina:Saleado:F:1936-05-30:224195:945-52-9161 Dorothy:Heather:Biewald:F:1939-05-29:171391:963-63-3808 Earnest:Cletus:Jarboe:M:1932-07-20:223012:959-27-8926 Eboni:Delphine:Saffell:F:1951-10-02:135359:992-45-4129 Ronnie:Fredric:Guyette:M:1968-06-16:80070:994-77-4966 Carlyn:Leeanna:Wythe:F:1929-04-24:261083:903-11-9081 Billy:Hong:Usack:M:1936-08-27:53636:992-78-6928 Charity:Sherlyn:Ankrum:F:1988-09-20:137210:964-48-3694 Ginette:Elsie:Stoneberger:F:2010-09-07:124046:976-13-3946 Renate:Neta:Truont:F:1915-06-21:130781:952-15-1041 Dirk:Elisha:Begum:M:1973-09-12:209207:996-61-7463 Carlyn:Gary:Simbeck:F:1980-05-07:254249:919-46-5099 Elias:Clifton:Messey:M:1949-07-21:246764:945-19-9938 Rebecca:Genny:Opal:F:1980-09-16:129188:969-29-6750 Collin:Dion:Jungen:M:1930-07-16:124419:957-66-7016 Devin:Ashley:Dibacco:M:2014-01-15:212964:938-92-9541 Leeanna:Andree:Bertus:F:1974-12-12:80771:964-86-5920 Corey:Madeline:Winkelmann:F:1979-12-17:295211:916-21-6455 Tamiko:Tameka:Mildenstein:F:1963-11-27:38517:949-91-6152 Timmy:Kraig:Billiar:M:1948-02-16:166473:990-84-5489 Adalberto:Lacy:Mengarelli:M:1991-12-26:281692:979-64-3480 Dannie:Lacy:Buscemi:M:1984-04-22:209305:918-51-3389 Donnell:Jefferson:Bavier:M:1916-05-29:229420:920-11-2390 Horacio:Leonard:Boehne:M:1988-09-09:172319:960-86-2843 Quentin:Cesar:Mchugh:M:1974-09-13:213198:906-17-8041 Natalia:Leanora:Scriven:F:1997-07-22:100329:945-53-9089 Audria:Latisha:Byczek:F:1945-06-26:123463:911-69-8714 KHADIJAH:JAUNITA:LASZLO:F:1968-01-15:26014:928357472 Cory:Dominic:Gabrial:M:1994-02-22:125375:975-94-7248 KIMBERLIE:SANTINA:VANASTEN:F:2003-11-18:67185:904341928 Mel:Giovanni:Poltorak:M:1950-12-03:56685:942-19-5717 Retha:Latoya:Kolthoff:F:2014-07-25:250400:925-67-8889 Paris:Korey:Rallison:M:1948-09-13:56315:966-79-4122 Nelle:Roxana:Hinnen:F:1935-12-22:20944:982-46-3336 Andres:Rhett:Weirick:M:2010-12-26:29995:916-78-5234 Bea:Shawna:Olney:F:1929-12-22:247768:988-52-7699 Adolfo:Robbie:Ennen:M:1974-10-21:152321:977-95-8227 Karina:Mitzie:Hanley:F:1936-02-27:184484:940-12-6447 Clelia:Annelle:Pirre:F:1942-06-16:234584:949-68-3836 Tabetha:Lauryn:Harlow:F:1999-12-16:108330:978-20-8984 Willian:Rico:Blowe:M:1933-02-24:225273:945-75-9852 Scottie:Rudolf:Godbout:M:1960-07-01:263799:960-13-9505 Truman:Dee:Ferreyra:M:1961-09-12:32519:994-76-9035 Louis:Bryon:Tharrington:M:1953-02-16:204469:906-31-5228 Shirley:Inocencia:Excell:F:1970-01-31:248064:946-59-8363 Carmen:Erin:Olynger:M:1951-09-21:199308:907-41-8142 Kena:Lynna:Heinold:F:1960-07-16:268246:959-23-2846 Charlott:Beth:Stutts:F:1916-08-30:299079:901-28-7722 Diego:Cristopher:Beulah:M:1953-03-19:219166:904-22-3169 Vanda:Elvia:Herskovits:F:1967-05-06:89811:902-89-4242 Berry:Horace:Raine:M:1955-01-20:150135:952-43-5452 Ted:Jonah:Stephenson:M:1991-03-03:151820:993-87-5979 Stanton:Maxwell:Schuch:M:1978-05-07:220253:961-51-4072 Sol:Thad:Korman:M:1917-08-18:279136:995-64-7338 Marcos:Carey:Haushalter:M:1919-07-14:220403:957-62-2787 Lea:Elvera:Kotek:F:1934-06-30:220894:995-43-8820 Orpha:Danyell:Samantha:F:1946-03-03:36348:925-32-2839 Elden:Dana:Lattig:M:1967-03-11:264076:987-71-3852 Sommer:Branda:Marolf:F:1927-08-01:78802:925-16-9620 Elias:Dominique:Fesus:M:1923-03-28:237688:958-63-3359 Herminia:Jackelyn:Gala:F:1948-10-16:222482:997-22-3232 Fernanda:Jane:Macbeth:F:1994-08-02:189359:939-49-3016 Ardith:Odilia:Hurde:F:1922-12-25:70193:981-19-5503 Jed:Erick:Reinard:M:1958-02-17:134245:948-47-2159 Kristofer:Zachary:Kortkamp:M:1980-03-29:240759:951-45-9829 Tarra:Valery:Vail:F:2012-03-30:81420:903-88-1117 Norene:Mistie:Anakalea:F:1946-04-27:186896:977-53-8371 Karan:Lila:Manson:F:1995-05-05:128276:906-69-1943 Siobhan:Corrin:Bartrop:F:1934-02-11:170626:988-97-4732 Conrad:Laurence:Lebeaux:M:1986-05-05:215581:983-27-5134 Mavis:Aurelia:Pfaffinger:F:1934-10-11:274931:940-46-6959 Saul:Efren:Pullam:M:1929-05-08:132160:905-82-7414 Olin:Johnathan:Gobin:M:1963-08-02:233710:955-16-9009 Gretta:Retha:Napps:F:1960-08-18:199846:946-85-1658 Les:Chas:Dunne:M:1977-09-06:158177:961-84-2979 Mafalda:Margeret:Gioffre:F:1993-07-05:284868:900-14-8327 Valentine:Clifton:Piening:M:1950-11-22:222267:906-33-4566 Lauretta:Shawnda:Colombe:F:1994-01-23:151865:955-26-4390 Tawana:Salena:Manzanilla:F:1971-11-20:60548:989-51-1112 Lucas:Thad:Mccurtain:M:1945-11-25:132463:914-99-2501 Demarcus:Sean:Trausch:M:2014-02-07:83494:974-32-9725 Santos:Kasey:Kolle:M:1988-01-03:298031:957-12-8163 Normand:Floyd:Tietje:M:1956-06-21:47947:944-14-4345 Brandy:Elana:Hakala:F:2015-01-05:280101:989-86-1263 Sherlene:Debbie:Kaloudis:F:2007-03-15:158198:958-25-3741 Marcela:Chris:Wrenn:F:1930-04-03:251170:952-70-7697 GROVER:DELMAR:MINSON:M:1976-10-12:119305:666764730 Fonda:Irena:Paget:F:1961-06-02:47796:920-43-5379 Lowell:Sherman:Bondroff:M:1957-05-16:293248:996-55-1269 Mitchel:David:Schapp:M:1995-07-13:64622:934-72-4881 Leann:Hermina:Oppenheim:F:1962-01-22:197108:919-12-9695 Grant:Cyril:Gradney:M:1942-12-21:126973:922-55-9841 Fritz:Len:Hoesly:M:1991-10-10:273720:990-18-5637 Bethany:Kristel:Cannan:F:1920-05-24:166552:958-93-6745 Patrica:Brittney:Jennison:F:1962-03-10:216165:993-53-7803 Manuel:Lester:Wormley:M:1985-09-15:29869:964-19-4455 Aurea:Darline:Voegeli:F:1942-05-10:171164:956-76-8847 Jayson:Donald:Maresh:M:1934-11-29:87804:982-55-9197 Linn:Shela:Schmier:F:1955-08-01:216566:970-18-1346 Abigail:Meghan:Delp:F:1953-01-02:45330:923-22-5410 Edgardo:Benjamin:Kosters:M:1999-05-06:172738:979-64-4752 Martin:Edmund:Cogswell:M:1930-05-21:19149:990-21-6669 Fatima:Melita:Piermont:F:1995-10-15:35848:980-47-6891 Matthew:Zachery:Hassler:M:1926-11-25:205813:994-42-4653 Gavin:Quinn:Murzyn:M:2005-06-23:296990:998-82-9934 Terri:Tamica:Franich:F:1920-12-19:15449:905-70-5059 Zandra:Ethelene:Trumbore:F:1995-09-07:98836:946-88-1372 Teofila:Eulah:Jett:F:1967-06-20:80872:927-73-1570 Fritz:Sang:Hail:M:1926-01-01:293653:970-92-5911 TERRENCE:JAE:ALLERMAN:M:1933-02-12:132100:952327784 Yang:Jayme:Barco:F:1981-10-25:281733:998-57-8714 Nick:Jesus:Mcphie:M:1919-06-02:263306:903-56-4683 Barney:Todd:Laster:M:1979-06-09:193460:957-46-5626 Alicia:Maya:Coletta:F:1990-06-20:58953:998-18-9746 Jarred:Dario:Lohmiller:M:2001-07-02:108399:961-38-7286 Hanh:Janetta:Jerrel:F:1929-05-09:151333:935-19-1087 Sherry:Gena:Leemow:F:1948-04-16:30391:957-58-1268 Amada:Elli:Syphard:F:1915-02-28:184463:929-25-7783 Emanuel:Major:Ozburn:M:1981-03-08:167784:947-70-3650 Vickey:Exie:Gubbins:F:1919-09-24:36472:996-60-6153 Birdie:Luise:Cozort:F:1950-12-06:37329:940-45-1500 Milan:Moises:Jaroski:M:1996-02-20:288589:900-39-5519 Karena:Myrl:Naki:F:1975-04-17:235639:923-59-5431 Roni:Patria:Hudek:F:1991-06-25:164405:915-40-1188 Noma:Soon:Lanka:F:2003-11-12:180365:904-87-6292 Kelley:Stuart:Loeschner:M:1975-11-02:222901:986-53-5302 Claudie:Georgina:Rackers:F:2001-01-04:158269:967-33-3087 Korey:Stacey:Schimler:M:1960-10-31:178323:981-44-6972 Shakita:Crista:Smeltzer:F:1957-03-31:287486:998-32-3350 Yolando:Rosamond:Dejaeger:F:1963-03-04:179273:917-60-6125 Thaddeus:Stacy:Holubar:M:1946-03-15:17009:979-22-1967 Amalia:Adina:Zoglmann:F:1982-05-26:90282:981-22-4249 Reda:Concha:Fetherolf:F:1930-07-31:36765:971-85-6669 Shalon:Cristin:Stimac:F:1921-09-08:35047:937-34-4405 Moses:Cordell:Wick:M:1915-01-02:87050:900-54-2401 Joaquin:Clint:Tredennick:M:1968-02-13:47418:905-94-9042 Kenya:Rebecca:Colicchio:F:2011-03-05:276402:934-17-3039 Vicente:Matt:Macconaghy:M:1959-07-16:224942:986-62-1762 Kizzie:Jene:Feickert:F:2009-05-10:284587:973-47-7568 Denice:Estela:Lechliter:F:1915-09-26:202439:952-47-7774 Shanelle:Ria:Balas:F:1935-04-15:169683:916-59-7328 Mai:Ngan:Quillan:F:1933-06-12:178666:945-94-7306 Esperanza:Misha:Sedler:F:1968-06-08:265831:989-59-9356 Scot:Elwood:Simper:M:1923-05-19:185805:942-53-8942 Patricia:Luetta:Menden:F:1946-02-16:177612:973-58-8254 Agnus:Theodora:Skeesick:F:1928-05-27:227267:938-39-6537 Estelle:Jammie:Nichter:F:1947-10-27:194228:951-70-8862 Francoise:Lizbeth:Coburn:F:1940-02-17:85476:987-80-5902 Palmira:Chris:Iverson:F:1969-11-28:157779:957-22-8564 Andrea:Rigoberto:Odeh:M:1996-05-27:257959:946-80-8050 WILFORD:PALMER:BESEMER:M:1922-01-22:245223:937506920 Normand:Deandre:Krylo:M:1998-01-02:98937:929-43-8095 Cecila:Linn:Kinsland:F:2000-03-30:150471:921-61-6038 Zoe:Sherry:Sowa:F:1932-02-21:243213:992-70-8085 Sharri:Teressa:Shedlock:F:1975-03-12:270688:971-95-2617 Eryn:Darcie:Haslinger:F:1986-08-11:260386:934-32-3454 Lillian:Melina:Bethurum:F:2000-07-26:33122:901-64-5476 Harlan:Elliot:Mendiaz:M:1996-06-19:195171:908-65-5414 Glen:Len:Hsueh:M:1969-07-12:184821:932-62-7454 Brenda:Minh:Schlichting:F:1979-03-23:221785:950-66-6868 Jeff:Julius:Day:M:2013-01-09:266378:943-27-4659 Sharika:Misha:Whitsey:F:1948-12-16:225322:983-81-8985 Linh:Tyra:Schiffelbein:F:1974-03-19:99974:922-86-5653 Lionel:Marcos:Centner:M:1927-11-21:37129:957-79-5652 Lynna:Maggie:Piersiak:F:1925-04-26:177612:902-66-8438 Zackary:Hank:Deveja:M:1996-05-07:164715:957-15-8098 Lovie:Jill:Vondielingen:F:1980-06-11:123228:920-92-6421 TAMIKO:ASHANTI:CHAVIRA:F:1980-02-24:111525:978891521 Minerva:Joni:Wells:F:2013-12-17:218016:968-23-9212 Broderick:Branden:Hoschander:M:1964-06-24:36306:962-30-2648 Theodora:Mirtha:Stringfellow:F:1966-03-03:49786:919-16-2194 Mathilda:Ilda:Mallinger:F:2008-10-19:44690:907-13-5809 Corinna:Easter:Kahler:F:2008-12-16:66871:978-18-2160 Liana:Leesa:Edlow:F:1960-08-12:40989:998-59-7725 Denna:Joy:Aiona:F:1952-02-14:135863:925-83-7076 Tiny:Keiko:Zanardi:F:1916-07-24:167794:999-46-5444 Cyrus:Royal:Areola:M:1995-12-17:290925:946-95-4528 Demetrice:Bobbye:Savocchia:F:2003-07-29:146340:985-38-6358 Gustavo:Rudy:Fundenberger:M:1931-03-26:26237:948-97-3335 Carmelo:Rosendo:Neisius:M:1979-04-02:110343:915-84-5747 Cruz:Alex:Ehmann:M:1958-09-25:85851:983-74-2493 Lanell:Melia:Korby:F:2014-03-23:38357:949-69-9656 Elvis:Quinton:Titch:M:1979-06-30:134356:989-15-5085 Rosemary:Azucena:Shelmon:F:2012-10-22:38275:922-71-4194 Kit:Cathey:Yerico:F:1936-05-05:220038:927-84-4977 Arden:Orlando:Byler:M:1977-07-02:124505:908-55-7026 Jarvis:Wilford:Palinkas:M:1971-12-16:198573:984-15-1697 Clarinda:Christa:Harstad:F:2013-05-06:180470:973-85-3544 Madelaine:Alex:Mantuano:F:2006-04-24:78805:946-66-1596 Tracy:Hilario:Loosli:M:1995-03-15:86893:982-38-4900 Nicolas:Stefan:Clement:M:1999-04-09:108944:999-57-3960 Tad:Collin:Didomenico:M:1972-07-07:20242:949-11-9664 Ernest:Michael:Rippey:M:1964-01-18:17218:998-94-5302 Wilda:Nellie:Burchette:F:1993-06-14:117591:931-62-9810 Seema:Eura:Delozier:F:2005-12-08:243999:918-90-7474 Zona:Bula:Pfrommer:F:1957-07-27:48232:987-93-3051 Maudie:Sharmaine:Glish:F:1932-01-09:158294:980-46-6241 Erich:Man:Trageser:M:1928-06-19:133075:907-11-6850 Farrah:Carolee:Ferrales:F:1978-08-13:128549:991-89-7685 Delfina:Sheilah:Ridell:F:1937-12-16:197044:999-25-2275 Rochelle:Leida:Calliste:F:1973-09-12:133103:925-11-8865 David:Lino:Turcotte:M:1932-04-16:165142:963-59-5949 Vanda:Kamala:Haseman:F:1936-04-10:110709:982-75-7088 Valda:Autumn:Melcher:F:1985-06-01:17721:910-61-7069 Zulema:Ming:Orrell:F:1942-08-21:213554:903-21-5959 Christine:Steffanie:Krzynowek:F:1972-02-18:64272:928-60-3212 Erline:Yasmine:Artola:F:1983-01-07:56916:974-50-2232 Gregg:Eric:Raterman:M:1940-01-03:86431:916-13-4495 Taylor:Guillermo:Folio:M:1950-12-21:268468:907-71-8161 Reena:Phillis:Twidwell:F:1931-12-26:219405:969-83-7062 Dean:Neal:Mohamed:M:2002-06-18:59506:944-33-8930 Willodean:Odessa:Biffle:F:1970-10-16:41874:998-13-3168 Werner:Winfred:Lanterman:M:1948-06-22:229604:977-70-9053 Kenton:Carter:Rexwinkle:M:1977-11-22:233049:938-19-7347 Mel:Vern:Monninger:M:1987-07-14:107282:937-47-7641 Renaldo:Emile:Dey:M:1965-02-16:72595:923-66-6665 Irwin:Errol:Fenk:M:1936-10-27:215604:992-21-8435 Silas:Terrence:Prokes:M:1946-10-17:112841:941-15-2185 Freddie:Alvina:Hallback:F:1992-07-13:88068:978-34-8517 Wyatt:Brady:Vanduyn:M:1954-01-20:28512:918-72-2716 Monroe:Pablo:Niehoff:M:1968-05-25:20930:971-59-8781 Antoinette:Dotty:Machol:F:1987-04-13:68097:966-73-3843 Elvin:Jarred:Wenk:M:1980-07-14:10857:966-68-8659 Don:Buck:Palen:M:1975-10-11:225054:938-38-8870 Mafalda:Rosalia:Phann:F:1979-01-03:43113:908-68-5365 Melody:Phyllis:Aljemal:F:1997-04-14:48593:912-15-3667 Kimbra:Carleen:Lubbock:F:2001-08-20:275609:969-71-2496 Sheldon:Mathew:Topolinski:M:1995-05-27:269105:938-40-2998 Natividad:Valerie:Lesch:F:1947-03-25:132574:935-58-4774 Demetrius:Prince:Summy:M:1989-08-05:135029:934-51-9675 Marinda:Buena:Calabro:F:1952-02-07:296023:974-29-9991 Ahmed:Austin:Rubiano:M:1962-02-22:31914:957-72-1368 Alexis:Ty:Noller:M:1954-11-18:165958:916-10-1425 Leontine:Celine:Piccuillo:F:1968-08-02:150888:907-88-9877 Kareen:Kina:Pepito:F:1989-11-01:129334:967-83-6137 Willian:Luke:Thuma:M:1970-11-01:166596:985-35-9120 Monroe:Nathan:Borgstrom:M:1948-02-05:252598:904-79-4850 Buck:Shelton:Wolden:M:2007-11-06:249439:959-23-1704 Kirk:Merrill:Pozzuoli:M:1939-06-04:240885:953-73-7289 Cruz:Conrad:Applonie:M:1989-10-19:225072:932-93-8417 Lester:Floyd:Debiase:M:1975-01-03:50092:973-43-7544 JAN:KASHA:ROBINETT:F:1915-03-27:285444:912946164 Cindie:Christel:Betzen:F:2006-12-09:12575:931-27-7425 Abe:Son:Greenbaum:M:1935-07-09:21434:968-97-8998 Larue:Vida:Kellman:F:1934-01-17:223652:960-33-7469 Marylin:Cyndy:Fonville:F:1988-09-26:61225:948-47-7367 Kazuko:Yajaira:Nellem:F:1943-01-11:152533:907-13-3546 Jordon:Harris:Hoop:M:1929-07-12:67892:916-34-5579 Brad:Mason:Rodrigues:M:1983-08-02:93301:981-37-4665 Shavonda:Aisha:Tietje:F:1945-08-14:241402:950-55-7705 Angele:Kathey:Rogacki:F:1929-01-09:147728:993-77-3525 REFUGIO:ALAN:DOUSSAN:M:1925-05-11:155093:981507241 Angele:Princess:Zipp:F:1983-04-10:167216:960-19-4409 Rolf:Mike:Gabossi:M:1988-02-21:75578:978-16-2933 Kimber:Jacki:Longs:F:1996-03-17:88738:918-50-4254 Eli:Murray:Sadlow:M:1934-04-10:118915:913-71-2081 Yesenia:Anette:Duitscher:F:2000-02-03:253164:991-50-1993 Travis:Roman:Fann:M:1961-01-05:77079:914-64-5405 Albertina:Stefani:Cavrak:F:2004-04-24:194522:943-29-3146 Delfina:Seema:Zuleger:F:1962-08-27:286421:901-31-6902 Carolyn:Jacqui:Hyatte:F:1925-05-16:287382:926-34-7305 Valarie:Deana:Mcelfresh:F:1960-06-28:242590:931-86-9529 Moshe:Lonnie:Clymore:M:1988-07-11:246124:927-48-6119 Burl:Stacy:Vent:M:1943-09-08:248473:997-64-2158 Sharan:Lashunda:Szalankiewicz:F:1980-09-24:290395:969-83-4153 Hunter:Jae:Hulsman:M:1975-11-14:170197:946-18-5917 Minh:Lawanda:Tassin:F:1976-07-16:40829:921-72-7006 Gordon:Aurelio:Gueth:M:1999-04-16:38484:940-40-2189 Burl:Tyson:Rewenko:M:2006-02-13:82563:998-43-9087 Rosana:Oralia:Unavailable:F:1929-12-16:252445:909-49-7585 Warner:Billy:Hunsinger:M:1918-05-12:100090:955-70-6028 Buck:Cary:Wion:M:1956-05-26:288373:994-18-7210 Stacey:Kareem:Strysko:M:1946-02-15:214450:909-39-4592 Gregg:Edmund:Cicchetti:M:1928-10-12:94976:904-81-5828 Robbie:Gilberto:Auprey:M:1973-08-29:151424:923-79-5699 Emilee:Shandi:Gillentine:F:2001-09-19:269749:960-54-9060 Mohammed:Russ:Mckibbin:M:1964-03-22:81035:993-30-9568 Jody:Thurman:Malkoski:M:1994-01-16:299348:995-11-5144 Maida:Remona:Bemrose:F:1961-04-14:39675:961-53-6489 Wally:Brady:Seryak:M:1962-01-01:10506:989-98-5050 Lakeesha:Dena:Marciel:F:1950-07-17:54058:905-32-7903 Glennie:Alane:Varnes:F:1949-08-06:49961:935-89-6400 Brandie:Carma:Giacobbe:F:1999-09-01:247964:991-60-8254 Genna:Willodean:Asamoah:F:1946-07-14:14796:959-21-8617 Tillie:Felica:Blasini:F:1950-01-19:269933:913-31-3187 Clement:Pasquale:Biven:M:1963-05-29:117346:666-40-9717 Elliot:Brendan:Sacane:M:1973-06-02:213718:974-79-2044 Lester:Jamel:Cuoco:M:1917-02-26:37555:997-41-5664 Elroy:Hal:Zuch:M:1984-04-06:151372:944-60-9997 Marti:Venetta:Volpert:F:1954-05-17:280499:987-20-6933 Krysta:Risa:General:F:1954-05-25:175829:944-29-5706 Olga:Rosy:Linwood:F:1994-07-02:279519:935-16-5499 Ailene:Roselee:Forcade:F:1926-09-06:143337:984-48-2586 Shad:Dorsey:Tillou:M:1961-09-11:257785:956-27-7927 Lanora:Sun:Diedrich:F:2015-04-16:26308:986-40-8770 Eugenio:Silas:Hoogendoorn:M:2012-03-08:61570:915-95-5402 Harley:Ivory:Pompa:M:1945-05-24:239159:934-91-8518 Ashlee:Flor:Seepersaud:F:2013-04-21:259959:976-36-5267 Dominick:Burton:Villarreal:M:1945-01-24:47271:923-50-3548 Karan:Eunice:Schamp:F:2004-09-18:286652:917-98-5383 Abel:Tobias:Braggs:M:2008-08-08:72055:989-88-5893 Heidi:Amie:Baison:F:2001-07-30:151363:981-22-8654 Juliane:Lizette:Mildenhall:F:1931-06-25:73612:937-93-5672 Anika:Marshall:Edwin:F:1980-03-28:101055:960-56-4111 Rickey:Eusebio:Remey:M:1968-11-05:27218:931-99-6609 Domingo:Anderson:Villalovos:M:2012-07-03:76851:999-79-1172 Woodrow:Elroy:Supnet:M:1948-10-04:107674:936-90-2731 Abe:Sherman:Osby:M:1972-01-04:154714:976-84-1452 Elizabet:Karin:Clattenburg:F:1932-02-27:265470:986-74-5047 Jacqulyn:Shantae:Glaspie:F:2007-08-15:143505:901-74-1679 Jack:Roberto:Defir:M:2012-11-10:286813:946-74-6720 Kathe:Kayleigh:Ritzie:F:1948-04-27:164314:955-34-2732 Kathaleen:Joanna:Shimizu:F:1940-09-22:239551:666-21-6079 Melvin:Les:Yearwood:M:1994-10-18:242120:997-39-4329 Kelly:Hyman:Kendrix:M:2012-06-16:57040:951-21-3167 Joy:Nichol:Bendas:F:1933-06-01:240785:905-15-3496 Julio:Adalberto:Kroc:M:1920-01-17:151781:948-49-5118 Giovanni:Oswaldo:Gosselin:M:1931-07-18:213905:995-32-6483 William:Jared:Cianciulli:M:1939-09-18:28651:974-23-7883 Ryan:Bruce:Noye:M:1958-04-16:104699:929-27-9179 PARKER:MELVIN:MARTINEA:M:1934-05-17:48971:984569507 Logan:Heike:Demesa:F:1976-04-08:142400:980-62-4825 Dinorah:Sally:Palu:F:1933-07-08:228359:956-34-9308 Napoleon:Jerome:Eeds:M:1952-11-16:60230:990-88-5493 Rupert:Randy:Subijano:M:1965-09-13:123613:911-40-9433 Stephan:Napoleon:Gloeckner:M:1998-07-25:17037:958-20-7026 Dusti:Sylvie:Fritch:F:1983-05-07:120032:906-99-9106 Yoshie:Calandra:Tompson:F:1975-01-07:82507:917-58-9043 Terra:Gabriella:Uhler:F:1970-08-22:251384:901-43-1310 Lionel:Delmer:Nahmias:M:1993-08-08:238247:924-87-1766 Earle:Wes:Casto:M:1977-02-11:102093:957-50-6785 Mertie:Jeraldine:Pietzsch:F:1943-06-24:86709:905-45-9584 Deangelo:Felipe:Whitledge:M:1923-09-14:47605:928-22-3600 Irving:Reggie:Dorvil:M:1951-11-26:261720:937-76-3750 Jonathan:Jonathon:Karlsen:M:1974-01-11:123094:992-96-6461 Anya:Phylicia:Soileau:F:1915-04-19:165565:953-13-3751 Delta:Tamra:Patuto:F:1989-04-26:138453:982-97-8384 Sari:Laureen:Lillibridge:F:1943-11-12:133813:955-52-8147 Dario:Ignacio:Speidell:M:1975-11-06:118465:956-63-6138 Berry:Ike:Bevard:M:2010-09-02:17232:972-69-8283 Anisa:Gerri:Henningson:F:1981-05-30:224237:910-22-9688 Therese:Vena:Tiemens:F:1947-11-27:16376:992-20-1576 Kasi:Faviola:Kolin:F:1990-04-28:208645:903-17-8868 Santo:Wiley:Mcnany:M:2007-06-05:190285:915-15-7359 Delmar:Carmen:Mearns:M:1962-05-18:36693:943-49-2675 Randy:Jerome:Bousman:M:1966-08-16:255899:944-92-2869 Judie:Denyse:Amentler:F:1953-03-25:56001:953-77-3286 Mose:Quincy:Roder:M:1920-11-07:85442:972-77-5076 Billy:Garrett:Lamarche:M:2000-08-16:297328:937-35-8713 Frances:Israel:Bonato:M:1947-09-19:84705:998-65-3686 SELINA:MARCIA:MUSTY:F:1977-06-01:290967:962202955 Shane:Mohammed:Aumann:M:1980-01-28:124727:907-14-7286 Erwin:Jamel:Oginski:M:2004-08-11:138805:906-89-6522 Gabriella:Kaitlyn:Stratakos:F:1933-10-10:290039:958-84-1597 Isaias:Porter:Tretheway:M:2010-03-29:43635:996-51-7006 Shaun:Columbus:Patil:M:1967-10-14:218418:912-34-6751 Ricky:Richard:Andon:M:1974-10-17:60015:994-29-7248 Jennefer:Adela:Hanback:F:1969-11-21:192409:945-14-1770 Grant:Pedro:Gastineau:M:1952-03-15:185675:980-59-5139 Anamaria:Caroyln:Minihan:F:1948-01-15:111866:997-98-8484 Rickie:Roman:Moret:M:1985-05-06:282451:959-84-9533 Assunta:Eve:Meigs:F:1968-11-25:227655:996-30-9209 Russ:Danilo:Wisseh:M:1957-01-26:156485:986-65-3418 Maribel:Lolita:Schulenberg:F:1924-09-25:10344:958-80-8982 Dessie:Marivel:Umbaugh:F:1994-09-27:200266:900-88-9736 Mimi:Almeda:Wakley:F:1964-02-19:169328:989-62-6548 Garfield:Salvador:Swantek:M:1935-10-02:222555:994-61-5642 Leon:Merlin:Nevins:M:1959-06-30:50692:980-48-9184 Kristi:Alejandrina:Guill:F:1928-10-21:150199:972-57-1273 SALLEY:CATALINA:BARNICLE:F:1946-12-09:78555:902407159 Charley:Irvin:Lussier:M:1966-10-20:191368:919-96-4151 Moises:Milton:Dunleavy:M:2010-05-04:253563:909-21-8881 Takisha:Elisha:Hillebrano:F:1968-01-13:89052:953-70-5814 Luther:Weston:Duchatellier:M:1937-05-01:239242:920-96-8708 Arnoldo:Victor:Brewen:M:2011-09-26:41795:954-81-3722 Duane:Arnulfo:Barnas:M:2006-12-07:73958:909-62-3922 Jacques:Terrell:Posas:M:2000-05-18:156446:901-26-9335 Rodolfo:Rosario:Baris:M:1922-12-05:114292:944-16-8986 Freeman:Dario:Dagrella:M:2001-12-27:44505:965-57-2682 Asa:Hyman:Chagnon:M:1
# ANSWER
 
sourceFile = "dbfs:/mnt/training/dataframes/people-with-dups.txt"
destFile = userhome + "/people.parquet"
 
# In case it already exists
dbutils.fs.rm(destFile, True)
Out[13]: False
# ANSWER
 
# dropDuplicates() will likely introduce a shuffle, so it helps to reduce the number of post-shuffle partitions.
spark.conf.set("spark.sql.shuffle.partitions", 8)
# ANSWER
 
# Okay, now we can read this thing.
 
df = (spark
    .read
    .option("header", "true")
    .option("inferSchema", "true")
    .option("sep", ":")
    .csv(sourceFile)
)
# ANSWER
from pyspark.sql.functions import *
 
dedupedDF = (df
  .select(col("*"),
      lower(col("firstName")).alias("lcFirstName"),
      lower(col("lastName")).alias("lcLastName"),
      lower(col("middleName")).alias("lcMiddleName"),
      translate(col("ssn"), "-", "").alias("ssnNums")
      # regexp_replace(col("ssn"), "-", "").alias("ssnNums")
      # regexp_replace(col("ssn"), """^(\d{3})(\d{2})(\d{4})$""", "$1-$2-$3").alias("ssnNums")
   )
  .dropDuplicates(["lcFirstName", "lcMiddleName", "lcLastName", "ssnNums", "gender", "birthDate", "salary"])
  .drop("lcFirstName", "lcMiddleName", "lcLastName", "ssnNums")
)
# ANSWER
 
# Now we can save the results. We'll also re-read them and count them, just as a final check.
# Just for fun, we'll use the Snappy compression codec. It's not as compact as Gzip, but it's much faster.
(dedupedDF.write
   .mode("overwrite")
   .option("compression", "snappy")
   .parquet(destFile)
)
dedupedDF = spark.read.parquet(destFile)
print(f"Total Records: {dedupedDF.count():,}")
Total Records: 100,000
# ANSWER
 
display( dbutils.fs.ls(destFile) )
 
path
name
size
1
2
3
4
5
6
7
8
9
10
11
dbfs:/user/ngaukahang@gmail.com/people.parquet/_SUCCESS
_SUCCESS
0
dbfs:/user/ngaukahang@gmail.com/people.parquet/_committed_2967102754690723764
_committed_2967102754690723764
832
dbfs:/user/ngaukahang@gmail.com/people.parquet/_started_2967102754690723764
_started_2967102754690723764
0
dbfs:/user/ngaukahang@gmail.com/people.parquet/part-00000-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2777-1-c000.snappy.parquet
part-00000-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2777-1-c000.snappy.parquet
437837
dbfs:/user/ngaukahang@gmail.com/people.parquet/part-00001-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2778-1-c000.snappy.parquet
part-00001-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2778-1-c000.snappy.parquet
439372
dbfs:/user/ngaukahang@gmail.com/people.parquet/part-00002-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2779-1-c000.snappy.parquet
part-00002-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2779-1-c000.snappy.parquet
433681
dbfs:/user/ngaukahang@gmail.com/people.parquet/part-00003-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2780-1-c000.snappy.parquet
part-00003-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2780-1-c000.snappy.parquet
431947
dbfs:/user/ngaukahang@gmail.com/people.parquet/part-00004-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2781-1-c000.snappy.parquet
part-00004-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2781-1-c000.snappy.parquet
428948
dbfs:/user/ngaukahang@gmail.com/people.parquet/part-00005-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2782-1-c000.snappy.parquet
part-00005-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2782-1-c000.snappy.parquet
435198
dbfs:/user/ngaukahang@gmail.com/people.parquet/part-00006-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2783-1-c000.snappy.parquet
part-00006-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2783-1-c000.snappy.parquet
435801
dbfs:/user/ngaukahang@gmail.com/people.parquet/part-00007-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2784-1-c000.snappy.parquet
part-00007-tid-2967102754690723764-4fbe960b-814a-489e-b0c5-790fc3184fa9-2784-1-c000.snappy.parquet
431940

Showing all 11 rows.

Spark Logo Tiny Validate Your Answer

At the bare minimum, we can verify that you wrote the parquet file out to destFile and that you have the right number of records.

Running the following cell to confirm your result:

partFiles = len(list(filter(lambda f: f.path.endswith(".parquet"), dbutils.fs.ls(destFile))))
 
finalDF = spark.read.parquet(destFile)
finalCount = finalDF.count()
 
clearYourResults()
validateYourAnswer("01 Parquet File Exists", 1276280174, partFiles)
validateYourAnswer("02 Expected 100000 Records", 972882115, finalCount)
summarizeYourResults()
01 Parquet File Exists was correct, your answer: 8 02 Expected 100000 Records was correct, your answer: 100000

Spark Logo Tiny Classroom-Cleanup

Run the Classroom-Cleanup cell below to remove any artifacts created by this lesson.

%run "../Includes/Classroom-Cleanup"